StudentAcademicYear

EntityType | Independent
Logical Entity Name | StudentAcademicYear
Default Table Name | FaStudentAY
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentAcademicYear Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentAcademicYearId |  | INTEGER | NO |
StudentEnrollmentPeriodId |  | INTEGER | NO |
AcademicYearId |  | INTEGER | NO |
ProgramVersionAcademicYearId |  | INTEGER | NO |
GradeLevelId |  | INTEGER | NO |
BudgetId |  | INTEGER | YES |
Sequence |  | SMALLINT | NO |
FaAdvisorId |  | INTEGER | YES |
StartDate |  | DATETIME | NO |
EndDate |  | DATETIME | NO |
FirstAwardYear |  | CHAR(7) | NO |
SecondAwardYear |  | CHAR(7) | YES |
IsFirstTimeBorrower |  | BIT | NO |
PackageDate |  | DATETIME | YES |
PackagingStatusId |  | INTEGER | NO |
IsPackageRevised |  | BIT | NO |
AwardNoticePrintedDate |  | DATETIME | YES |
AwardNoticeSigned |  | DATETIME | YES |
RevisedAwardNoticePrinted |  | DATETIME | YES |
RevisedAwardNoticeSigned |  | DATETIME | YES |
WeeksInAcademicYear |  | NUMERIC(4, 1) | YES |
MonthsIncademicYear |  | NUMERIC(4, 1) | YES |
WeeksNonEnrollment |  | NUMERIC(4, 1) | YES |
CreditHoursInAcademicYear |  | NUMERIC(7, 2) | YES |
CostOfAttendance |  | MONEY(19, 4) | YES |
Tuition |  | MONEY(19, 4) | YES |
BooksSupplies |  | MONEY(19, 4) | YES |
RoomBoard |  | MONEY(19, 4) | YES |
Travel |  | MONEY(19, 4) | YES |
OtherCostDescription1 |  | VARCHAR(40) | YES |
OtherCostAmount1 |  | MONEY(19, 4) | YES |
OtherCostDescription2 |  | VARCHAR(40) | YES |
OtherCostAmount2 |  | MONEY(19, 4) | YES |
OtherCostDescription3 |  | VARCHAR(40) | YES |
OtherCostAmount3 |  | MONEY(19, 4) | YES |
OtherCostDescription4 |  | VARCHAR(40) | YES |
OtherCostAmount4 |  | MONEY(19, 4) | YES |
PellCostOfAttendance |  | MONEY(19, 4) | YES |
WeeksEnrolledInAcademicYear |  | INTEGER | YES |
CreditHoursExpectedToComplete |  | NUMERIC(9, 2) | YES |
Note |  | VARCHAR(4000) | YES |
BilledDate |  | DATETIME | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
InstitutionalCharges |  | MONEY(19, 4) | YES |
PackagingMethodId |  | INTEGER | YES |
OtherCostAmount5 |  | MONEY(19, 4) | YES |
OtherCostAmount6 |  | MONEY(19, 4) | YES |
OtherCostAmount7 |  | MONEY(19, 4) | YES |
OtherCostAmount8 |  | MONEY(19, 4) | YES |
OtherCostDescription5 |  | CHAR(40) | YES |
OtherCostDescription6 |  | CHAR(40) | YES |
OtherCostDescription7 |  | CHAR(40) | YES |
OtherCostDescription8 |  | CHAR(40) | YES |
IsOtherCostInstitutionalCharge1 |  | BIT | NO |
IsOtherCostInstitutionalCharge2 |  | BIT | NO |
IsOtherCostInstitutionalCharge3 |  | BIT | NO |
IsOtherCostInstitutionalCharge4 |  | BIT | NO |
IsOtherCostInstitutionalCharge5 |  | BIT | NO |
IsOtherCostInstitutionalCharge6 |  | BIT | NO |
IsOtherCostInstitutionalCharge7 |  | BIT | NO |
IsOtherCostInstitutionalCharge8 |  | BIT | NO |
AcYrNote |  | VARCHAR(3000) | YES |
LenderFees |  | MONEY(19, 4) | NO |
BudgetRecordIdentifier |  | CHAR(20) | YES |
PackagedToEnrollmentStatusId |  | INTEGER | YES |
HousingStatusCode |  | CHAR(1) | YES |
IsHybridDates |  | BIT | NO |
SecondAwardYearPackagingStatusId |  | INTEGER | YES |
IsUnsubEligibilityUpToHeal |  | BIT | NO |
TeachCounselingDate |  | DATETIME | YES |
IsUnsupportedDependent |  | BIT | NO |
IsAutoAwardBudgetLock |  | BIT | NO |
IsAutoAwardPackageLock |  | BIT | NO |
AutoAwardEvaluationType |  | CHAR(1) | YES |
AutoAwardRequestProcess |  | VARCHAR(200) | YES |
HPPALevel |  | CHAR(1) | NO |
PLUSCreditDecisionStatus |  | CHAR(1) | YES |
IsSummerPackagingExcluded |  | BIT | NO |
AutoAwardConfigurationId |  | INTEGER | YES |
AutoAwardInitialCalculationDate |  | DATETIME | YES |
AutoAwardRepackageCalculationDate |  | DATETIME | YES |
IsReentryAcademicYear |  | BIT | YES |
IsStartDateExcluded |  | BIT | NO |
IsEndDateExcluded |  | BIT | NO |
CounselingCompleteDate |  | DATETIME | YES |
CounselingType |  | VARCHAR(50) | YES |
AutoAwardEnrollmentStatusId |  | INTEGER | YES |
IWINAY |  | NUMERIC(4, 1) | NO |
IWMonths |  | NUMERIC(4, 1) | NO |
RefWeeksInAcademicYear |  | NUMERIC(4, 1) | YES |
RefCreditHoursInAcademicYear |  | NUMERIC(7, 2) | YES |
TermsToPackageDirectLoan |  | VARCHAR(max) | NO |

StudentAcademicYear Keys

Key Name | Key Type | Keys
FaStudentAY_AwardYear1_N_N_IDX | Inversion Entry | FirstAwardYear
NK_FaStudentAY_FirstTimeBorrower_INCL | Inversion Entry | IsFirstTimeBorrower
Nk_FaStudentAyAutoAwardAdAttStatId | Inversion Entry | AutoAwardEnrollmentStatusId
NK_FaStudentAYStartDate | Inversion Entry | StartDate
FaStudentAY_FaPackStatusID_N_N_IDX | Inversion Entry | PackagingStatusId
FaStudentAY_FaBudgetID_N_N_IDX | Inversion Entry | BudgetId
FaStudentAY_StartDate_PackageDate_N_N_IDX | Inversion Entry | StartDate, PackageDate
FaStudentAY_FaProgramAYSeqID_N_N_IDX | Inversion Entry | ProgramVersionAcademicYearId
FaStudentAY_AwardYear2_N_N_IDX | Inversion Entry | SecondAwardYear
Nk_FaStudentAy_AdEnrollID_FaPackStatusID_FaAutoAwardPopulationConfigurationId | Inversion Entry | AutoAwardConfigurationId
Nk_FaStudentAyFaAutoAwardPopulationConfigurationId | Inversion Entry | AutoAwardConfigurationId
FaStudentAY_EndDate_N_N_IDX | Inversion Entry | EndDate
FaStudentAY_BudGetRecordId_N_N_IDX | Inversion Entry | BudgetRecordIdentifier
FaStudentAY_FAStudentAYID_U_C_IDX | PrimaryKey | StudentAcademicYearId
FaStudentAY_AdEnrollID_Sequence_N_N_IDX | Inversion Entry | StudentEnrollmentPeriodId, Sequence
FaStudentAY_StartDate_EndDate_FaPackStatusID_AdEnrollID_N_N_IDX | Inversion Entry | StartDate, EndDate, PackagingStatusId, StudentEnrollmentPeriodId
FaStudentAY_AdEnrollID_N_N_IDX | Inversion Entry | StudentEnrollmentPeriodId

StudentAcademicYear Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
PackagingStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | SecondAwardYearPackagingStatusId | NO
Budget | Non-Identifying | Zero or One to Zero or More |  |  |  | BudgetId | NO
PackagingStatus | Non-Identifying | One To Zero or More |  |  |  | PackagingStatusId | NO
EnrollmentStatus | Non-Identifying | Zero or One to Zero or More |  |  |  | AutoAwardEnrollmentStatusId | NO
AutoAwardConfiguration | Non-Identifying | Zero or One to Zero or More |  |  |  | AutoAwardConfigurationId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
AwardLetterPrintQueue | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaPackStatusQueue | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAcademicYearLoanPeriodDateAudit | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAward | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaStudentAidCashPlanHistory | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAcademicYearComment | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAcademicYearPaymentPeriod | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaStudentMaster | Non-Identifying | One To Zero or More |  |  |  |  | NO
HousingLease | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyAudit_FaStudentAY | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyAudit_FaStudentAYPaymentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
StudentRt4Calculation | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentAcademicYear Check Constraints

Check Constraint Name | CheckConstraint

StudentAcademicYear Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAcademicYear | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaStudentAY | NO |  |  |

StudentAcademicYear Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | RefundCalculation
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

StudentAcademicYear Data Movement Rules

Name | Type | Rule Text/Value